Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 14606 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.9 MiB |
| Average record size in memory | 208.0 B |
Variable types
| Text | 1 |
|---|---|
| Categorical | 3 |
| Numeric | 17 |
| DateTime | 4 |
| Boolean | 1 |
cons_12m is highly overall correlated with cons_last_month and 2 other fields | High correlation |
cons_gas_12m is highly overall correlated with nb_prod_act | High correlation |
cons_last_month is highly overall correlated with cons_12m and 2 other fields | High correlation |
forecast_cons_12m is highly overall correlated with cons_12m and 3 other fields | High correlation |
forecast_cons_year is highly overall correlated with cons_last_month and 3 other fields | High correlation |
forecast_meter_rent_12m is highly overall correlated with forecast_price_energy_off_peak and 3 other fields | High correlation |
forecast_price_energy_off_peak is highly overall correlated with forecast_meter_rent_12m and 2 other fields | High correlation |
forecast_price_energy_peak is highly overall correlated with forecast_meter_rent_12m and 2 other fields | High correlation |
forecast_price_pow_off_peak is highly overall correlated with forecast_meter_rent_12m and 3 other fields | High correlation |
imp_cons is highly overall correlated with cons_last_month and 3 other fields | High correlation |
margin_gross_pow_ele is highly overall correlated with margin_net_pow_ele | High correlation |
margin_net_pow_ele is highly overall correlated with margin_gross_pow_ele | High correlation |
nb_prod_act is highly overall correlated with cons_gas_12m | High correlation |
net_margin is highly overall correlated with cons_12m and 3 other fields | High correlation |
pow_max is highly overall correlated with forecast_meter_rent_12m and 3 other fields | High correlation |
churn is highly imbalanced (54.0%) | Imbalance |
net_margin is highly skewed (γ1 = 36.56951466) | Skewed |
id has unique values | Unique |
cons_gas_12m has 11994 (82.1%) zeros | Zeros |
cons_last_month has 4983 (34.1%) zeros | Zeros |
forecast_cons_12m has 306 (2.1%) zeros | Zeros |
forecast_cons_year has 6148 (42.1%) zeros | Zeros |
forecast_discount_energy has 14094 (96.5%) zeros | Zeros |
forecast_meter_rent_12m has 725 (5.0%) zeros | Zeros |
forecast_price_energy_peak has 7021 (48.1%) zeros | Zeros |
imp_cons has 6169 (42.2%) zeros | Zeros |
margin_gross_pow_ele has 157 (1.1%) zeros | Zeros |
margin_net_pow_ele has 157 (1.1%) zeros | Zeros |
net_margin has 185 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-14 19:38:26.076999 |
|---|---|
| Analysis finished | 2023-08-14 19:38:51.000673 |
| Duration | 24.92 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
id
Text
UNIQUE
| Distinct | 14606 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 467392 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 14606 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 24011ae4ebbe3035111d65fa7c15bc57 |
|---|---|
| 2nd row | d29c2c54acc38ff3c0614d0a653813dd |
| 3rd row | 764c75f661154dac3a6c254cd082ea7d |
| 4th row | bba03439a292a1e166f80264c16191cb |
| 5th row | 149d57cf92fc41cf94415803a877cb4b |
| Value | Count | Frequency (%) |
| 24011ae4ebbe3035111d65fa7c15bc57 | 1 | < 0.1% |
| 26c7bba7d51f86a16109de505bcd4f52 | 1 | < 0.1% |
| 74ff037708f036de5745ce34d8d9d4df | 1 | < 0.1% |
| 21860c2ff2d5df75503b230ce629c253 | 1 | < 0.1% |
| 764c75f661154dac3a6c254cd082ea7d | 1 | < 0.1% |
| bba03439a292a1e166f80264c16191cb | 1 | < 0.1% |
| 149d57cf92fc41cf94415803a877cb4b | 1 | < 0.1% |
| 1aa498825382410b098937d65c4ec26d | 1 | < 0.1% |
| 7ab4bf4878d8f7661dfc20e9b8e18011 | 1 | < 0.1% |
| 01495c955be7ec5e7f3203406785aae0 | 1 | < 0.1% |
| Other values (14596) | 14596 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 29453 | 6.3% |
| e | 29432 | 6.3% |
| 7 | 29400 | 6.3% |
| 4 | 29381 | 6.3% |
| 2 | 29375 | 6.3% |
| b | 29313 | 6.3% |
| 3 | 29297 | 6.3% |
| 1 | 29257 | 6.3% |
| c | 29210 | 6.2% |
| a | 29169 | 6.2% |
| Other values (6) | 174105 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 292239 | |
| Lowercase Letter | 175153 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 29453 | |
| 7 | 29400 | |
| 4 | 29381 | |
| 2 | 29375 | |
| 3 | 29297 | |
| 1 | 29257 | |
| 8 | 29153 | |
| 0 | 29090 | |
| 9 | 29012 | |
| 5 | 28821 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 29432 | |
| b | 29313 | |
| c | 29210 | |
| a | 29169 | |
| d | 29137 | |
| f | 28892 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 292239 | |
| Latin | 175153 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 29453 | |
| 7 | 29400 | |
| 4 | 29381 | |
| 2 | 29375 | |
| 3 | 29297 | |
| 1 | 29257 | |
| 8 | 29153 | |
| 0 | 29090 | |
| 9 | 29012 | |
| 5 | 28821 |
Latin
| Value | Count | Frequency (%) |
| e | 29432 | |
| b | 29313 | |
| c | 29210 | |
| a | 29169 | |
| d | 29137 | |
| f | 28892 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 467392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 29453 | 6.3% |
| e | 29432 | 6.3% |
| 7 | 29400 | 6.3% |
| 4 | 29381 | 6.3% |
| 2 | 29375 | 6.3% |
| b | 29313 | 6.3% |
| 3 | 29297 | 6.3% |
| 1 | 29257 | 6.3% |
| c | 29210 | 6.2% |
| a | 29169 | 6.2% |
| Other values (6) | 174105 |
channel_sales
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| foosdfpfkusacimwkcsosbicdxkicaua | |
|---|---|
| MISSING | |
| lmkebamcaaclubfxadlmueccxoimlema | |
| usilxuppasemubllopkaafesmlibmsdf | |
| ewpakwlliwisiwduibdlfmalxowmwpci | |
| Other values (3) | 16 |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 25.624196 |
| Min length | 7 |
Characters and Unicode
| Total characters | 374267 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | foosdfpfkusacimwkcsosbicdxkicaua |
|---|---|
| 2nd row | MISSING |
| 3rd row | foosdfpfkusacimwkcsosbicdxkicaua |
| 4th row | lmkebamcaaclubfxadlmueccxoimlema |
| 5th row | MISSING |
Common Values
| Value | Count | Frequency (%) |
| foosdfpfkusacimwkcsosbicdxkicaua | 6754 | |
| MISSING | 3725 | |
| lmkebamcaaclubfxadlmueccxoimlema | 1843 | 12.6% |
| usilxuppasemubllopkaafesmlibmsdf | 1375 | 9.4% |
| ewpakwlliwisiwduibdlfmalxowmwpci | 893 | 6.1% |
| sddiedcslfslkckwlfkdpoeeailfpeds | 11 | 0.1% |
| epumfxlbckeskwekxbiuasklxalciiuu | 3 | < 0.1% |
| fixdbufsefwooaasfcxdxadsiekoceaa | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| foosdfpfkusacimwkcsosbicdxkicaua | 6754 | |
| missing | 3725 | |
| lmkebamcaaclubfxadlmueccxoimlema | 1843 | 12.6% |
| usilxuppasemubllopkaafesmlibmsdf | 1375 | 9.4% |
| ewpakwlliwisiwduibdlfmalxowmwpci | 893 | 6.1% |
| sddiedcslfslkckwlfkdpoeeailfpeds | 11 | 0.1% |
| epumfxlbckeskwekxbiuasklxalciiuu | 3 | < 0.1% |
| fixdbufsefwooaasfcxdxadsiekoceaa | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 35415 | 9.5% |
| c | 35313 | 9.4% |
| s | 33465 | 8.9% |
| i | 29355 | 7.8% |
| f | 25792 | 6.9% |
| k | 24420 | 6.5% |
| o | 24390 | 6.5% |
| u | 22226 | 5.9% |
| m | 21883 | 5.8% |
| d | 18573 | 5.0% |
| Other values (11) | 103435 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 348192 | |
| Uppercase Letter | 26075 | 7.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 35415 | |
| c | 35313 | |
| s | 33465 | |
| i | 29355 | 8.4% |
| f | 25792 | 7.4% |
| k | 24420 | 7.0% |
| o | 24390 | 7.0% |
| u | 22226 | 6.4% |
| m | 21883 | 6.3% |
| d | 18573 | 5.3% |
| Other values (6) | 77360 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 7450 | |
| S | 7450 | |
| M | 3725 | |
| N | 3725 | |
| G | 3725 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 374267 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 35415 | 9.5% |
| c | 35313 | 9.4% |
| s | 33465 | 8.9% |
| i | 29355 | 7.8% |
| f | 25792 | 6.9% |
| k | 24420 | 6.5% |
| o | 24390 | 6.5% |
| u | 22226 | 5.9% |
| m | 21883 | 5.8% |
| d | 18573 | 5.0% |
| Other values (11) | 103435 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 374267 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 35415 | 9.5% |
| c | 35313 | 9.4% |
| s | 33465 | 8.9% |
| i | 29355 | 7.8% |
| f | 25792 | 6.9% |
| k | 24420 | 6.5% |
| o | 24390 | 6.5% |
| u | 22226 | 5.9% |
| m | 21883 | 5.8% |
| d | 18573 | 5.0% |
| Other values (11) | 103435 |
cons_12m
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11065 |
|---|---|
| Distinct (%) | 75.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 159220.29 |
| Minimum | 0 |
|---|---|
| Maximum | 6207104 |
| Zeros | 117 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1512.25 |
| Q1 | 5674.75 |
| median | 14115.5 |
| Q3 | 40763.75 |
| 95-th percentile | 913771.75 |
| Maximum | 6207104 |
| Range | 6207104 |
| Interquartile range (IQR) | 35089 |
Descriptive statistics
| Standard deviation | 573465.26 |
|---|---|
| Coefficient of variation (CV) | 3.6017098 |
| Kurtosis | 42.689777 |
| Mean | 159220.29 |
| Median Absolute Deviation (MAD) | 10669 |
| Skewness | 5.9973081 |
| Sum | 2.3255715 × 109 |
| Variance | 3.2886241 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 117 | 0.8% |
| 2882597 | 27 | 0.2% |
| 3329244 | 24 | 0.2% |
| 1743025 | 18 | 0.1% |
| 3926060 | 18 | 0.1% |
| 6207104 | 18 | 0.1% |
| 1722179 | 17 | 0.1% |
| 2288838 | 17 | 0.1% |
| 2503923 | 16 | 0.1% |
| 963288 | 16 | 0.1% |
| Other values (11055) | 14318 |
| Value | Count | Frequency (%) |
| 0 | 117 | |
| 1 | 2 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 4 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 6207104 | 18 | |
| 5731448 | 14 | |
| 5322441 | 1 | < 0.1% |
| 5161456 | 4 | < 0.1% |
| 4939487 | 4 | < 0.1% |
| 4406520 | 14 | |
| 4306656 | 9 | |
| 4199490 | 5 | < 0.1% |
| 4100379 | 13 | |
| 4012564 | 2 | < 0.1% |
cons_gas_12m
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2112 |
|---|---|
| Distinct (%) | 14.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28092.375 |
| Minimum | 0 |
|---|---|
| Maximum | 4154590 |
| Zeros | 11994 |
| Zeros (%) | 82.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 75854 |
| Maximum | 4154590 |
| Range | 4154590 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 162973.06 |
|---|---|
| Coefficient of variation (CV) | 5.8013271 |
| Kurtosis | 126.33363 |
| Mean | 28092.375 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.59753 |
| Sum | 4.1031723 × 108 |
| Variance | 2.6560218 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 11994 | |
| 976731 | 27 | 0.2% |
| 867921 | 24 | 0.2% |
| 41532 | 18 | 0.1% |
| 1959386 | 18 | 0.1% |
| 1192414 | 17 | 0.1% |
| 475413 | 16 | 0.1% |
| 468369 | 15 | 0.1% |
| 1337056 | 14 | 0.1% |
| 187578 | 13 | 0.1% |
| Other values (2102) | 2450 | 16.8% |
| Value | Count | Frequency (%) |
| 0 | 11994 | |
| 11 | 7 | < 0.1% |
| 12 | 2 | < 0.1% |
| 21 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| 35 | 2 | < 0.1% |
| 36 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 43 | 2 | < 0.1% |
| 46 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4154590 | 2 | < 0.1% |
| 2813019 | 2 | < 0.1% |
| 2055098 | 2 | < 0.1% |
| 1959386 | 18 | |
| 1860052 | 4 | < 0.1% |
| 1859491 | 3 | < 0.1% |
| 1813943 | 1 | < 0.1% |
| 1711930 | 1 | < 0.1% |
| 1653924 | 2 | < 0.1% |
| 1542867 | 1 | < 0.1% |
cons_last_month
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 4751 |
|---|---|
| Distinct (%) | 32.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16090.27 |
| Minimum | 0 |
|---|---|
| Maximum | 771203 |
| Zeros | 4983 |
| Zeros (%) | 34.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 792.5 |
| Q3 | 3383 |
| 95-th percentile | 82161.5 |
| Maximum | 771203 |
| Range | 771203 |
| Interquartile range (IQR) | 3383 |
Descriptive statistics
| Standard deviation | 64364.196 |
|---|---|
| Coefficient of variation (CV) | 4.0001937 |
| Kurtosis | 47.762991 |
| Mean | 16090.27 |
| Median Absolute Deviation (MAD) | 792.5 |
| Skewness | 6.391407 |
| Sum | 2.3501448 × 108 |
| Variance | 4.1427498 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4983 | |
| 382647 | 27 | 0.2% |
| 509826 | 24 | 0.2% |
| 558120 | 18 | 0.1% |
| 469210 | 18 | 0.1% |
| 106161 | 18 | 0.1% |
| 181187 | 17 | 0.1% |
| 237044 | 17 | 0.1% |
| 54281 | 16 | 0.1% |
| 313018 | 16 | 0.1% |
| Other values (4741) | 9452 |
| Value | Count | Frequency (%) |
| 0 | 4983 | |
| 1 | 13 | 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 5 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 771203 | 14 | |
| 760727 | 1 | < 0.1% |
| 612247 | 1 | < 0.1% |
| 558120 | 18 | |
| 509826 | 24 | |
| 507598 | 14 | |
| 479030 | 9 | 0.1% |
| 469898 | 2 | < 0.1% |
| 469210 | 18 | |
| 456462 | 5 | < 0.1% |
date_activ
Date
| Distinct | 1796 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| Minimum | 2003-05-09 00:00:00 |
|---|---|
| Maximum | 2014-09-01 00:00:00 |
Histogram with fixed size bins (bins=50)
date_end
Date
| Distinct | 368 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| Minimum | 2016-01-28 00:00:00 |
|---|---|
| Maximum | 2017-06-13 00:00:00 |
Histogram with fixed size bins (bins=50)
date_modif_prod
Date
| Distinct | 2129 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| Minimum | 2003-05-09 00:00:00 |
|---|---|
| Maximum | 2016-01-29 00:00:00 |
Histogram with fixed size bins (bins=50)
date_renewal
Date
| Distinct | 386 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| Minimum | 2013-06-26 00:00:00 |
|---|---|
| Maximum | 2016-01-28 00:00:00 |
Histogram with fixed size bins (bins=50)
forecast_cons_12m
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 13993 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1868.6149 |
| Minimum | 0 |
|---|---|
| Maximum | 82902.83 |
| Zeros | 306 |
| Zeros (%) | 2.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 84.9175 |
| Q1 | 494.995 |
| median | 1112.875 |
| Q3 | 2401.79 |
| 95-th percentile | 6127.095 |
| Maximum | 82902.83 |
| Range | 82902.83 |
| Interquartile range (IQR) | 1906.795 |
Descriptive statistics
| Standard deviation | 2387.5715 |
|---|---|
| Coefficient of variation (CV) | 1.2777226 |
| Kurtosis | 147.42668 |
| Mean | 1868.6149 |
| Median Absolute Deviation (MAD) | 752.955 |
| Skewness | 7.1558526 |
| Sum | 27292989 |
| Variance | 5700497.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 306 | 2.1% |
| 0.15 | 6 | < 0.1% |
| 415.14 | 4 | < 0.1% |
| 0.45 | 3 | < 0.1% |
| 1539.37 | 3 | < 0.1% |
| 651.21 | 3 | < 0.1% |
| 442.74 | 3 | < 0.1% |
| 335.5 | 3 | < 0.1% |
| 0.3 | 3 | < 0.1% |
| 303.93 | 3 | < 0.1% |
| Other values (13983) | 14269 |
| Value | Count | Frequency (%) |
| 0 | 306 | |
| 0.1 | 1 | < 0.1% |
| 0.15 | 6 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.3 | 3 | < 0.1% |
| 0.32 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.42 | 2 | < 0.1% |
| 0.45 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 82902.83 | 1 | |
| 61357.17 | 1 | |
| 48412.58 | 1 | |
| 35789.29 | 1 | |
| 35312.21 | 1 | |
| 32174.47 | 1 | |
| 31347.11 | 1 | |
| 30533.99 | 1 | |
| 28375.76 | 1 | |
| 27618.39 | 1 |
forecast_cons_year
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 4218 |
|---|---|
| Distinct (%) | 28.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1399.7629 |
| Minimum | 0 |
|---|---|
| Maximum | 175375 |
| Zeros | 6148 |
| Zeros (%) | 42.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 314 |
| Q3 | 1745.75 |
| 95-th percentile | 5968.75 |
| Maximum | 175375 |
| Range | 175375 |
| Interquartile range (IQR) | 1745.75 |
Descriptive statistics
| Standard deviation | 3247.7863 |
|---|---|
| Coefficient of variation (CV) | 2.3202403 |
| Kurtosis | 653.73441 |
| Mean | 1399.7629 |
| Median Absolute Deviation (MAD) | 314 |
| Skewness | 16.58799 |
| Sum | 20444937 |
| Variance | 10548116 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6148 | |
| 1 | 13 | 0.1% |
| 8 | 13 | 0.1% |
| 7 | 11 | 0.1% |
| 453 | 11 | 0.1% |
| 2 | 9 | 0.1% |
| 524 | 9 | 0.1% |
| 310 | 9 | 0.1% |
| 420 | 9 | 0.1% |
| 173 | 9 | 0.1% |
| Other values (4208) | 8365 |
| Value | Count | Frequency (%) |
| 0 | 6148 | |
| 1 | 13 | 0.1% |
| 2 | 9 | 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 8 | 0.1% |
| 5 | 7 | < 0.1% |
| 6 | 5 | < 0.1% |
| 7 | 11 | 0.1% |
| 8 | 13 | 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 175375 | 1 | |
| 79127 | 1 | |
| 70180 | 1 | |
| 66643 | 1 | |
| 63969 | 1 | |
| 59460 | 1 | |
| 51604 | 1 | |
| 51336 | 1 | |
| 50106 | 1 | |
| 46491 | 1 |
forecast_discount_energy
Real number (ℝ)
ZEROS
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.966726 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 14094 |
| Zeros (%) | 96.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.1082887 |
|---|---|
| Coefficient of variation (CV) | 5.2841122 |
| Kurtosis | 24.854712 |
| Mean | 0.966726 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1550983 |
| Sum | 14120 |
| Variance | 26.094613 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 14094 | |
| 30 | 260 | 1.8% |
| 28 | 102 | 0.7% |
| 24 | 83 | 0.6% |
| 22 | 47 | 0.3% |
| 25 | 7 | < 0.1% |
| 26 | 5 | < 0.1% |
| 19 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 14094 | |
| 5 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 19 | 2 | < 0.1% |
| 22 | 47 | 0.3% |
| 23 | 2 | < 0.1% |
| 24 | 83 | 0.6% |
| 25 | 7 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 30 | 260 | |
| 28 | 102 | 0.7% |
| 26 | 5 | < 0.1% |
| 25 | 7 | < 0.1% |
| 24 | 83 | 0.6% |
| 23 | 2 | < 0.1% |
| 22 | 47 | 0.3% |
| 19 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
forecast_meter_rent_12m
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 3528 |
|---|---|
| Distinct (%) | 24.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.086871 |
| Minimum | 0 |
|---|---|
| Maximum | 599.31 |
| Zeros | 725 |
| Zeros (%) | 5.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3325 |
| Q1 | 16.18 |
| median | 18.795 |
| Q3 | 131.03 |
| 95-th percentile | 145.72 |
| Maximum | 599.31 |
| Range | 599.31 |
| Interquartile range (IQR) | 114.85 |
Descriptive statistics
| Standard deviation | 66.165783 |
|---|---|
| Coefficient of variation (CV) | 1.0488043 |
| Kurtosis | 4.4915214 |
| Mean | 63.086871 |
| Median Absolute Deviation (MAD) | 9.315 |
| Skewness | 1.5051479 |
| Sum | 921446.84 |
| Variance | 4377.9108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 725 | 5.0% |
| 131.76 | 238 | 1.6% |
| 18.32 | 162 | 1.1% |
| 18.37 | 131 | 0.9% |
| 129.61 | 103 | 0.7% |
| 15.98 | 100 | 0.7% |
| 131.38 | 78 | 0.5% |
| 18.47 | 77 | 0.5% |
| 16.26 | 76 | 0.5% |
| 18.42 | 74 | 0.5% |
| Other values (3518) | 12842 |
| Value | Count | Frequency (%) |
| 0 | 725 | |
| 0.09 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| 0.31 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.34 | 2 | < 0.1% |
| 0.35 | 2 | < 0.1% |
| 0.36 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 599.31 | 5 | |
| 585.62 | 1 | < 0.1% |
| 562.13 | 1 | < 0.1% |
| 552.9 | 1 | < 0.1% |
| 548.41 | 1 | < 0.1% |
| 439.67 | 1 | < 0.1% |
| 434.04 | 1 | < 0.1% |
| 407.98 | 1 | < 0.1% |
| 407.97 | 9 | |
| 406.45 | 1 | < 0.1% |
forecast_price_energy_off_peak
Real number (ℝ)
HIGH CORRELATION
| Distinct | 516 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13728327 |
| Minimum | 0 |
|---|---|
| Maximum | 0.273963 |
| Zeros | 22 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.11293 |
| Q1 | 0.11634 |
| median | 0.143166 |
| Q3 | 0.146348 |
| 95-th percentile | 0.166178 |
| Maximum | 0.273963 |
| Range | 0.273963 |
| Interquartile range (IQR) | 0.030008 |
Descriptive statistics
| Standard deviation | 0.024622862 |
|---|---|
| Coefficient of variation (CV) | 0.17935808 |
| Kurtosis | 8.3645386 |
| Mean | 0.13728327 |
| Median Absolute Deviation (MAD) | 0.019738 |
| Skewness | -0.11958602 |
| Sum | 2005.1594 |
| Variance | 0.00060628535 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.145711 | 933 | 6.4% |
| 0.144902 | 732 | 5.0% |
| 0.115174 | 726 | 5.0% |
| 0.146694 | 644 | 4.4% |
| 0.115237 | 595 | 4.1% |
| 0.11691 | 449 | 3.1% |
| 0.1169 | 406 | 2.8% |
| 0.146348 | 339 | 2.3% |
| 0.143166 | 335 | 2.3% |
| 0.116509 | 308 | 2.1% |
| Other values (506) | 9139 |
| Value | Count | Frequency (%) |
| 0 | 22 | 0.2% |
| 0.0006 | 66 | |
| 0.000901 | 6 | < 0.1% |
| 0.092453 | 73 | |
| 0.094486 | 1 | < 0.1% |
| 0.095022 | 2 | < 0.1% |
| 0.095061 | 1 | < 0.1% |
| 0.095558 | 1 | < 0.1% |
| 0.095919 | 1 | < 0.1% |
| 0.096095 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.273963 | 18 | |
| 0.273957 | 2 | < 0.1% |
| 0.272981 | 21 | |
| 0.272972 | 1 | < 0.1% |
| 0.245926 | 8 | 0.1% |
| 0.245347 | 6 | < 0.1% |
| 0.237776 | 11 | 0.1% |
| 0.236794 | 4 | < 0.1% |
| 0.236291 | 3 | < 0.1% |
| 0.229272 | 34 |
forecast_price_energy_peak
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 329 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.050490767 |
| Minimum | 0 |
|---|---|
| Maximum | 0.195975 |
| Zeros | 7021 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.084138 |
| Q3 | 0.098837 |
| 95-th percentile | 0.10175 |
| Maximum | 0.195975 |
| Range | 0.195975 |
| Interquartile range (IQR) | 0.098837 |
Descriptive statistics
| Standard deviation | 0.049036507 |
|---|---|
| Coefficient of variation (CV) | 0.97119751 |
| Kurtosis | -1.8907547 |
| Mean | 0.050490767 |
| Median Absolute Deviation (MAD) | 0.0311955 |
| Skewness | -0.014331428 |
| Sum | 737.46815 |
| Variance | 0.002404579 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7021 | |
| 0.098837 | 722 | 4.9% |
| 0.100123 | 596 | 4.1% |
| 0.100015 | 473 | 3.2% |
| 0.100572 | 445 | 3.0% |
| 0.101397 | 308 | 2.1% |
| 0.103487 | 288 | 2.0% |
| 0.087381 | 169 | 1.2% |
| 0.086803 | 159 | 1.1% |
| 0.099419 | 153 | 1.0% |
| Other values (319) | 4272 |
| Value | Count | Frequency (%) |
| 0 | 7021 | |
| 0.076592 | 1 | < 0.1% |
| 0.077124 | 1 | < 0.1% |
| 0.078125 | 1 | < 0.1% |
| 0.078641 | 2 | < 0.1% |
| 0.078859 | 1 | < 0.1% |
| 0.079221 | 2 | < 0.1% |
| 0.079281 | 2 | < 0.1% |
| 0.079771 | 1 | < 0.1% |
| 0.079799 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.195975 | 1 | < 0.1% |
| 0.168092 | 6 | < 0.1% |
| 0.168032 | 7 | < 0.1% |
| 0.146676 | 8 | 0.1% |
| 0.136336 | 59 | |
| 0.13608 | 1 | < 0.1% |
| 0.135761 | 5 | < 0.1% |
| 0.135732 | 35 | |
| 0.135182 | 3 | < 0.1% |
| 0.134604 | 2 | < 0.1% |
forecast_price_pow_off_peak
Real number (ℝ)
HIGH CORRELATION
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.130056 |
| Minimum | 0 |
|---|---|
| Maximum | 59.266378 |
| Zeros | 94 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40.606701 |
| Q1 | 40.606701 |
| median | 44.311378 |
| Q3 | 44.311378 |
| 95-th percentile | 46.305378 |
| Maximum | 59.266378 |
| Range | 59.266378 |
| Interquartile range (IQR) | 3.704677 |
Descriptive statistics
| Standard deviation | 4.4859882 |
|---|---|
| Coefficient of variation (CV) | 0.10401072 |
| Kurtosis | 54.708041 |
| Mean | 43.130056 |
| Median Absolute Deviation (MAD) | 0.9969996 |
| Skewness | -4.998772 |
| Sum | 629957.59 |
| Variance | 20.12409 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=41)
| Value | Count | Frequency (%) |
| 44.31137796 | 6933 | |
| 40.606701 | 4651 | |
| 45.80687796 | 697 | 4.8% |
| 46.30537836 | 615 | 4.2% |
| 45.30837756 | 419 | 2.9% |
| 41.1052014 | 302 | 2.1% |
| 40.9390266 | 237 | 1.6% |
| 41.2713642 | 160 | 1.1% |
| 58.99595196 | 118 | 0.8% |
| 0 | 94 | 0.6% |
| Other values (31) | 380 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 94 | 0.6% |
| 35.55576792 | 1 | < 0.1% |
| 37.929294 | 2 | < 0.1% |
| 40.606701 | 4651 | |
| 40.728885 | 31 | 0.2% |
| 40.9390266 | 237 | 1.6% |
| 41.1052014 | 302 | 2.1% |
| 41.1067014 | 1 | < 0.1% |
| 41.2713642 | 160 | 1.1% |
| 41.2718682 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 59.26637796 | 42 | 0.3% |
| 59.17346796 | 76 | |
| 59.05128396 | 1 | < 0.1% |
| 58.99595196 | 118 | |
| 53.28437796 | 14 | 0.1% |
| 47.80087836 | 8 | 0.1% |
| 47.30687796 | 2 | < 0.1% |
| 47.30237796 | 10 | 0.1% |
| 46.80687756 | 1 | < 0.1% |
| 46.80387756 | 6 | < 0.1% |
has_gas
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 11955 | |
| True | 2651 | 18.2% |
imp_cons
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 7752 |
|---|---|
| Distinct (%) | 53.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152.7869 |
| Minimum | 0 |
|---|---|
| Maximum | 15042.79 |
| Zeros | 6169 |
| Zeros (%) | 42.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 37.395 |
| Q3 | 193.98 |
| 95-th percentile | 638.8175 |
| Maximum | 15042.79 |
| Range | 15042.79 |
| Interquartile range (IQR) | 193.98 |
Descriptive statistics
| Standard deviation | 341.36937 |
|---|---|
| Coefficient of variation (CV) | 2.2342843 |
| Kurtosis | 380.8937 |
| Mean | 152.7869 |
| Median Absolute Deviation (MAD) | 37.395 |
| Skewness | 13.198799 |
| Sum | 2231605.4 |
| Variance | 116533.04 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6169 | |
| 0.3 | 5 | < 0.1% |
| 0.1 | 5 | < 0.1% |
| 34.53 | 4 | < 0.1% |
| 26.26 | 4 | < 0.1% |
| 42.04 | 4 | < 0.1% |
| 126.6 | 4 | < 0.1% |
| 26.51 | 4 | < 0.1% |
| 117.18 | 4 | < 0.1% |
| 0.15 | 4 | < 0.1% |
| Other values (7742) | 8399 |
| Value | Count | Frequency (%) |
| 0 | 6169 | |
| 0.06 | 1 | < 0.1% |
| 0.09 | 2 | < 0.1% |
| 0.1 | 5 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.15 | 4 | < 0.1% |
| 0.17 | 2 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| 0.28 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 15042.79 | 1 | |
| 9682.89 | 1 | |
| 8732.6 | 1 | |
| 8254.16 | 1 | |
| 6787.12 | 1 | |
| 5836.49 | 1 | |
| 5343.76 | 1 | |
| 5311.97 | 1 | |
| 5019.25 | 1 | |
| 4925.36 | 1 |
margin_gross_pow_ele
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2391 |
|---|---|
| Distinct (%) | 16.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.565121 |
| Minimum | 0 |
|---|---|
| Maximum | 374.64 |
| Zeros | 157 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.56 |
| Q1 | 14.28 |
| median | 21.64 |
| Q3 | 29.88 |
| 95-th percentile | 51.72 |
| Maximum | 374.64 |
| Range | 374.64 |
| Interquartile range (IQR) | 15.6 |
Descriptive statistics
| Standard deviation | 20.231172 |
|---|---|
| Coefficient of variation (CV) | 0.82357305 |
| Kurtosis | 35.892607 |
| Mean | 24.565121 |
| Median Absolute Deviation (MAD) | 8.12 |
| Skewness | 4.4726321 |
| Sum | 358798.16 |
| Variance | 409.30031 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26.04 | 258 | 1.8% |
| 33.12 | 238 | 1.6% |
| 29.76 | 170 | 1.2% |
| 34.68 | 161 | 1.1% |
| 0 | 157 | 1.1% |
| 16.92 | 156 | 1.1% |
| 23.76 | 156 | 1.1% |
| 10.08 | 151 | 1.0% |
| 19.2 | 141 | 1.0% |
| 14.64 | 135 | 0.9% |
| Other values (2381) | 12883 |
| Value | Count | Frequency (%) |
| 0 | 157 | |
| 0.03 | 1 | < 0.1% |
| 0.12 | 125 | |
| 0.24 | 16 | 0.1% |
| 0.36 | 7 | < 0.1% |
| 0.48 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.64 | 7 | < 0.1% |
| 0.66 | 1 | < 0.1% |
| 0.68 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 374.64 | 1 | |
| 314.76 | 1 | |
| 299.64 | 1 | |
| 248.64 | 1 | |
| 225.12 | 2 | |
| 224.89 | 1 | |
| 224.64 | 1 | |
| 219.88 | 1 | |
| 214.35 | 1 | |
| 214.14 | 1 |
margin_net_pow_ele
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2391 |
|---|---|
| Distinct (%) | 16.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.562517 |
| Minimum | 0 |
|---|---|
| Maximum | 374.64 |
| Zeros | 157 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.56 |
| Q1 | 14.28 |
| median | 21.64 |
| Q3 | 29.88 |
| 95-th percentile | 51.72 |
| Maximum | 374.64 |
| Range | 374.64 |
| Interquartile range (IQR) | 15.6 |
Descriptive statistics
| Standard deviation | 20.23028 |
|---|---|
| Coefficient of variation (CV) | 0.82362404 |
| Kurtosis | 35.901232 |
| Mean | 24.562517 |
| Median Absolute Deviation (MAD) | 8.12 |
| Skewness | 4.4733258 |
| Sum | 358760.13 |
| Variance | 409.26422 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26.04 | 258 | 1.8% |
| 33.12 | 238 | 1.6% |
| 29.76 | 170 | 1.2% |
| 34.68 | 161 | 1.1% |
| 0 | 157 | 1.1% |
| 16.92 | 156 | 1.1% |
| 23.76 | 156 | 1.1% |
| 10.08 | 151 | 1.0% |
| 19.2 | 141 | 1.0% |
| 14.64 | 135 | 0.9% |
| Other values (2381) | 12883 |
| Value | Count | Frequency (%) |
| 0 | 157 | |
| 0.03 | 1 | < 0.1% |
| 0.12 | 125 | |
| 0.24 | 16 | 0.1% |
| 0.36 | 7 | < 0.1% |
| 0.48 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.64 | 7 | < 0.1% |
| 0.66 | 1 | < 0.1% |
| 0.68 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 374.64 | 1 | |
| 314.76 | 1 | |
| 299.64 | 1 | |
| 248.64 | 1 | |
| 225.12 | 2 | |
| 224.89 | 1 | |
| 224.64 | 1 | |
| 219.88 | 1 | |
| 214.35 | 1 | |
| 214.14 | 1 |
nb_prod_act
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2923456 |
| Minimum | 1 |
|---|---|
| Maximum | 32 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 32 |
| Range | 31 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.70977352 |
|---|---|
| Coefficient of variation (CV) | 0.54921339 |
| Kurtosis | 258.95725 |
| Mean | 1.2923456 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.6368779 |
| Sum | 18876 |
| Variance | 0.50377845 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1 | 11431 | |
| 2 | 2445 | 16.7% |
| 3 | 523 | 3.6% |
| 4 | 150 | 1.0% |
| 5 | 31 | 0.2% |
| 9 | 11 | 0.1% |
| 6 | 8 | 0.1% |
| 8 | 4 | < 0.1% |
| 10 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 11431 | |
| 2 | 2445 | 16.7% |
| 3 | 523 | 3.6% |
| 4 | 150 | 1.0% |
| 5 | 31 | 0.2% |
| 6 | 8 | 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 11 | 0.1% |
| 10 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 32 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 11 | 0.1% |
| 8 | 4 | < 0.1% |
| 6 | 8 | 0.1% |
| 5 | 31 | 0.2% |
| 4 | 150 | 1.0% |
| 3 | 523 | 3.6% |
| 2 | 2445 | 16.7% |
| 1 | 11431 |
net_margin
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 11965 |
|---|---|
| Distinct (%) | 81.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 189.26452 |
| Minimum | 0 |
|---|---|
| Maximum | 24570.65 |
| Zeros | 185 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11.16 |
| Q1 | 50.7125 |
| median | 112.53 |
| Q3 | 243.0975 |
| 95-th percentile | 587.685 |
| Maximum | 24570.65 |
| Range | 24570.65 |
| Interquartile range (IQR) | 192.385 |
Descriptive statistics
| Standard deviation | 311.79813 |
|---|---|
| Coefficient of variation (CV) | 1.6474198 |
| Kurtosis | 2642.9653 |
| Mean | 189.26452 |
| Median Absolute Deviation (MAD) | 75.32 |
| Skewness | 36.569515 |
| Sum | 2764397.6 |
| Variance | 97218.074 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 185 | 1.3% |
| 0.49 | 6 | < 0.1% |
| 35.98 | 5 | < 0.1% |
| 57.37 | 5 | < 0.1% |
| 86.52 | 5 | < 0.1% |
| 56.33 | 5 | < 0.1% |
| 0.01 | 5 | < 0.1% |
| 234.83 | 4 | < 0.1% |
| 78.22 | 4 | < 0.1% |
| 33.8 | 4 | < 0.1% |
| Other values (11955) | 14378 |
| Value | Count | Frequency (%) |
| 0 | 185 | |
| 0.01 | 5 | < 0.1% |
| 0.02 | 4 | < 0.1% |
| 0.03 | 3 | < 0.1% |
| 0.04 | 3 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 1 | < 0.1% |
| 0.09 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 24570.65 | 1 | |
| 10203.5 | 1 | |
| 4346.37 | 1 | |
| 4305.79 | 1 | |
| 3768.16 | 1 | |
| 3407.65 | 1 | |
| 3403.27 | 1 | |
| 3323.02 | 1 | |
| 3215.03 | 1 | |
| 2711.19 | 1 |
num_years_antig
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.9978091 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 5 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6117493 |
|---|---|
| Coefficient of variation (CV) | 0.32249116 |
| Kurtosis | 4.0781495 |
| Mean | 4.9978091 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.4462138 |
| Sum | 72998 |
| Variance | 2.5977357 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 6 | 4769 | |
| 4 | 3982 | |
| 3 | 2433 | |
| 5 | 2317 | |
| 7 | 509 | 3.5% |
| 11 | 185 | 1.3% |
| 12 | 110 | 0.8% |
| 8 | 103 | 0.7% |
| 9 | 92 | 0.6% |
| 10 | 81 | 0.6% |
| Other values (3) | 25 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 11 | 0.1% |
| 3 | 2433 | |
| 4 | 3982 | |
| 5 | 2317 | |
| 6 | 4769 | |
| 7 | 509 | 3.5% |
| 8 | 103 | 0.7% |
| 9 | 92 | 0.6% |
| 10 | 81 | 0.6% |
| Value | Count | Frequency (%) |
| 13 | 13 | 0.1% |
| 12 | 110 | 0.8% |
| 11 | 185 | 1.3% |
| 10 | 81 | 0.6% |
| 9 | 92 | 0.6% |
| 8 | 103 | 0.7% |
| 7 | 509 | 3.5% |
| 6 | 4769 | |
| 5 | 2317 | |
| 4 | 3982 |
origin_up
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| lxidpiddsbxsbosboudacockeimpuepw | |
|---|---|
| kamkkxfxxuwbdslkwifmmcsiusiuosws | |
| ldkssxwpmemidmecebumciepifcamkci | |
| MISSING | 64 |
| usapbepcfoloekilkwsdiboslwaxobdp | 2 |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 31.890456 |
| Min length | 7 |
Characters and Unicode
| Total characters | 465792 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | lxidpiddsbxsbosboudacockeimpuepw |
|---|---|
| 2nd row | kamkkxfxxuwbdslkwifmmcsiusiuosws |
| 3rd row | kamkkxfxxuwbdslkwifmmcsiusiuosws |
| 4th row | kamkkxfxxuwbdslkwifmmcsiusiuosws |
| 5th row | kamkkxfxxuwbdslkwifmmcsiusiuosws |
Common Values
| Value | Count | Frequency (%) |
| lxidpiddsbxsbosboudacockeimpuepw | 7097 | |
| kamkkxfxxuwbdslkwifmmcsiusiuosws | 4294 | |
| ldkssxwpmemidmecebumciepifcamkci | 3148 | |
| MISSING | 64 | 0.4% |
| usapbepcfoloekilkwsdiboslwaxobdp | 2 | < 0.1% |
| ewxeelcelemmiwuafmddpobolfuxioce | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lxidpiddsbxsbosboudacockeimpuepw | 7097 | |
| kamkkxfxxuwbdslkwifmmcsiusiuosws | 4294 | |
| ldkssxwpmemidmecebumciepifcamkci | 3148 | |
| missing | 64 | 0.4% |
| usapbepcfoloekilkwsdiboslwaxobdp | 2 | < 0.1% |
| ewxeelcelemmiwuafmddpobolfuxioce | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 49063 | |
| i | 46771 | |
| d | 38984 | 8.4% |
| m | 35722 | 7.7% |
| c | 31084 | 6.7% |
| k | 30573 | 6.6% |
| u | 30228 | 6.5% |
| x | 30228 | 6.5% |
| b | 28740 | 6.2% |
| p | 27594 | 5.9% |
| Other values (11) | 116805 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 465344 | |
| Uppercase Letter | 448 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 49063 | |
| i | 46771 | |
| d | 38984 | 8.4% |
| m | 35722 | 7.7% |
| c | 31084 | 6.7% |
| k | 30573 | 6.6% |
| u | 30228 | 6.5% |
| x | 30228 | 6.5% |
| b | 28740 | 6.2% |
| p | 27594 | 5.9% |
| Other values (6) | 116357 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 128 | |
| S | 128 | |
| M | 64 | |
| N | 64 | |
| G | 64 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 465792 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 49063 | |
| i | 46771 | |
| d | 38984 | 8.4% |
| m | 35722 | 7.7% |
| c | 31084 | 6.7% |
| k | 30573 | 6.6% |
| u | 30228 | 6.5% |
| x | 30228 | 6.5% |
| b | 28740 | 6.2% |
| p | 27594 | 5.9% |
| Other values (11) | 116805 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 465792 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 49063 | |
| i | 46771 | |
| d | 38984 | 8.4% |
| m | 35722 | 7.7% |
| c | 31084 | 6.7% |
| k | 30573 | 6.6% |
| u | 30228 | 6.5% |
| x | 30228 | 6.5% |
| b | 28740 | 6.2% |
| p | 27594 | 5.9% |
| Other values (11) | 116805 |
pow_max
Real number (ℝ)
HIGH CORRELATION
| Distinct | 698 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.135136 |
| Minimum | 3.3 |
|---|---|
| Maximum | 320 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.2 KiB |
Quantile statistics
| Minimum | 3.3 |
|---|---|
| 5-th percentile | 10.39 |
| Q1 | 12.5 |
| median | 13.856 |
| Q3 | 19.1725 |
| 95-th percentile | 41.5 |
| Maximum | 320 |
| Range | 316.7 |
| Interquartile range (IQR) | 6.6725 |
Descriptive statistics
| Standard deviation | 13.534743 |
|---|---|
| Coefficient of variation (CV) | 0.74632711 |
| Kurtosis | 59.202563 |
| Mean | 18.135136 |
| Median Absolute Deviation (MAD) | 3.056 |
| Skewness | 5.7867849 |
| Sum | 264881.79 |
| Variance | 183.18928 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13.2 | 2124 | 14.5% |
| 10.392 | 2000 | 13.7% |
| 13.856 | 1504 | 10.3% |
| 15 | 583 | 4.0% |
| 10.35 | 480 | 3.3% |
| 19.8 | 416 | 2.8% |
| 16.5 | 405 | 2.8% |
| 20 | 294 | 2.0% |
| 12.5 | 269 | 1.8% |
| 13.15 | 234 | 1.6% |
| Other values (688) | 6297 |
| Value | Count | Frequency (%) |
| 3.3 | 3 | |
| 3.464 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2 | |
| 5.196 | 2 | |
| 5.75 | 2 | |
| 6 | 2 | |
| 6.9 | 1 | < 0.1% |
| 6.928 | 4 | |
| 7.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 320 | 1 | < 0.1% |
| 260 | 1 | < 0.1% |
| 200 | 4 | |
| 192 | 1 | < 0.1% |
| 180 | 2 | |
| 166 | 1 | < 0.1% |
| 164 | 1 | < 0.1% |
| 160 | 2 | |
| 155.88 | 1 | < 0.1% |
| 155 | 3 |
churn
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 14606 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 14606 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 14606 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14606 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 13187 | |
| 1 | 1419 | 9.7% |
| cons_12m | cons_gas_12m | cons_last_month | forecast_cons_12m | forecast_cons_year | forecast_discount_energy | forecast_meter_rent_12m | forecast_price_energy_off_peak | forecast_price_energy_peak | forecast_price_pow_off_peak | imp_cons | margin_gross_pow_ele | margin_net_pow_ele | nb_prod_act | net_margin | num_years_antig | pow_max | channel_sales | has_gas | origin_up | churn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cons_12m | 1.000 | 0.161 | 0.707 | 0.695 | 0.429 | -0.024 | 0.288 | -0.286 | 0.323 | -0.364 | 0.411 | -0.094 | -0.094 | 0.119 | 0.688 | -0.010 | 0.350 | 0.140 | 0.234 | 0.066 | 0.049 |
| cons_gas_12m | 0.161 | 1.000 | 0.148 | 0.137 | 0.091 | 0.005 | 0.058 | -0.048 | 0.065 | -0.075 | 0.093 | -0.026 | -0.026 | 0.865 | 0.134 | -0.002 | 0.076 | 0.063 | 0.302 | 0.036 | 0.037 |
| cons_last_month | 0.707 | 0.148 | 1.000 | 0.443 | 0.771 | -0.018 | 0.351 | -0.284 | 0.377 | -0.370 | 0.759 | -0.002 | -0.002 | 0.109 | 0.445 | 0.009 | 0.351 | 0.117 | 0.231 | 0.046 | 0.041 |
| forecast_cons_12m | 0.695 | 0.137 | 0.443 | 1.000 | 0.508 | 0.052 | 0.258 | -0.249 | 0.267 | -0.325 | 0.515 | -0.175 | -0.175 | 0.125 | 0.950 | -0.060 | 0.340 | 0.000 | 0.025 | 0.054 | 0.019 |
| forecast_cons_year | 0.429 | 0.091 | 0.771 | 0.508 | 1.000 | 0.014 | 0.426 | -0.371 | 0.435 | -0.444 | 0.987 | -0.011 | -0.011 | 0.072 | 0.516 | -0.013 | 0.425 | 0.000 | 0.000 | 0.016 | 0.000 |
| forecast_discount_energy | -0.024 | 0.005 | -0.018 | 0.052 | 0.014 | 1.000 | -0.003 | 0.275 | 0.090 | 0.149 | 0.033 | 0.241 | 0.240 | 0.144 | 0.018 | -0.083 | 0.003 | 0.025 | 0.019 | 0.033 | 0.023 |
| forecast_meter_rent_12m | 0.288 | 0.058 | 0.351 | 0.258 | 0.426 | -0.003 | 1.000 | -0.608 | 0.690 | -0.625 | 0.397 | 0.116 | 0.116 | 0.034 | 0.293 | 0.006 | 0.660 | 0.038 | 0.058 | 0.063 | 0.042 |
| forecast_price_energy_off_peak | -0.286 | -0.048 | -0.284 | -0.249 | -0.371 | 0.275 | -0.608 | 1.000 | -0.470 | 0.714 | -0.321 | 0.041 | 0.041 | 0.012 | -0.325 | -0.035 | -0.670 | 0.086 | 0.068 | 0.084 | 0.050 |
| forecast_price_energy_peak | 0.323 | 0.065 | 0.377 | 0.267 | 0.435 | 0.090 | 0.690 | -0.470 | 1.000 | -0.731 | 0.400 | 0.176 | 0.176 | 0.065 | 0.326 | -0.017 | 0.706 | 0.078 | 0.061 | 0.073 | 0.041 |
| forecast_price_pow_off_peak | -0.364 | -0.075 | -0.370 | -0.325 | -0.444 | 0.149 | -0.625 | 0.714 | -0.731 | 1.000 | -0.392 | -0.139 | -0.140 | -0.030 | -0.423 | 0.003 | -0.715 | 0.076 | 0.069 | 0.073 | 0.055 |
| imp_cons | 0.411 | 0.093 | 0.759 | 0.515 | 0.987 | 0.033 | 0.397 | -0.321 | 0.400 | -0.392 | 1.000 | -0.017 | -0.017 | 0.077 | 0.501 | -0.029 | 0.387 | 0.000 | 0.021 | 0.038 | 0.000 |
| margin_gross_pow_ele | -0.094 | -0.026 | -0.002 | -0.175 | -0.011 | 0.241 | 0.116 | 0.041 | 0.176 | -0.139 | -0.017 | 1.000 | 1.000 | -0.001 | -0.119 | -0.041 | 0.263 | 0.022 | 0.019 | 0.040 | 0.089 |
| margin_net_pow_ele | -0.094 | -0.026 | -0.002 | -0.175 | -0.011 | 0.240 | 0.116 | 0.041 | 0.176 | -0.140 | -0.017 | 1.000 | 1.000 | -0.001 | -0.119 | -0.041 | 0.263 | 0.022 | 0.019 | 0.040 | 0.089 |
| nb_prod_act | 0.119 | 0.865 | 0.109 | 0.125 | 0.072 | 0.144 | 0.034 | 0.012 | 0.065 | -0.030 | 0.077 | -0.001 | -0.001 | 1.000 | 0.108 | -0.013 | 0.048 | 0.016 | 0.115 | 0.016 | 0.000 |
| net_margin | 0.688 | 0.134 | 0.445 | 0.950 | 0.516 | 0.018 | 0.293 | -0.325 | 0.326 | -0.423 | 0.501 | -0.119 | -0.119 | 0.108 | 1.000 | -0.056 | 0.406 | 0.000 | 0.017 | 0.012 | 0.027 |
| num_years_antig | -0.010 | -0.002 | 0.009 | -0.060 | -0.013 | -0.083 | 0.006 | -0.035 | -0.017 | 0.003 | -0.029 | -0.041 | -0.041 | -0.013 | -0.056 | 1.000 | -0.026 | 0.241 | 0.043 | 0.256 | 0.087 |
| pow_max | 0.350 | 0.076 | 0.351 | 0.340 | 0.425 | 0.003 | 0.660 | -0.670 | 0.706 | -0.715 | 0.387 | 0.263 | 0.263 | 0.048 | 0.406 | -0.026 | 1.000 | 0.006 | 0.030 | 0.039 | 0.026 |
| channel_sales | 0.140 | 0.063 | 0.117 | 0.000 | 0.000 | 0.025 | 0.038 | 0.086 | 0.078 | 0.076 | 0.000 | 0.022 | 0.022 | 0.016 | 0.000 | 0.241 | 0.006 | 1.000 | 0.053 | 0.254 | 0.081 |
| has_gas | 0.234 | 0.302 | 0.231 | 0.025 | 0.000 | 0.019 | 0.058 | 0.068 | 0.061 | 0.069 | 0.021 | 0.019 | 0.019 | 0.115 | 0.017 | 0.043 | 0.030 | 0.053 | 1.000 | 0.002 | 0.023 |
| origin_up | 0.066 | 0.036 | 0.046 | 0.054 | 0.016 | 0.033 | 0.063 | 0.084 | 0.073 | 0.073 | 0.038 | 0.040 | 0.040 | 0.016 | 0.012 | 0.256 | 0.039 | 0.254 | 0.002 | 1.000 | 0.097 |
| churn | 0.049 | 0.037 | 0.041 | 0.019 | 0.000 | 0.023 | 0.042 | 0.050 | 0.041 | 0.055 | 0.000 | 0.089 | 0.089 | 0.000 | 0.027 | 0.087 | 0.026 | 0.081 | 0.023 | 0.097 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| id | channel_sales | cons_12m | cons_gas_12m | cons_last_month | date_activ | date_end | date_modif_prod | date_renewal | forecast_cons_12m | forecast_cons_year | forecast_discount_energy | forecast_meter_rent_12m | forecast_price_energy_off_peak | forecast_price_energy_peak | forecast_price_pow_off_peak | has_gas | imp_cons | margin_gross_pow_ele | margin_net_pow_ele | nb_prod_act | net_margin | num_years_antig | origin_up | pow_max | churn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 24011ae4ebbe3035111d65fa7c15bc57 | foosdfpfkusacimwkcsosbicdxkicaua | 0 | 54946 | 0 | 2013-06-15 | 2016-06-15 | 2015-11-01 | 2015-06-23 | 0.00 | 0 | 0.0 | 1.78 | 0.114481 | 0.098142 | 40.606701 | t | 0.00 | 25.44 | 25.44 | 2 | 678.99 | 3 | lxidpiddsbxsbosboudacockeimpuepw | 43.648 | 1 |
| 1 | d29c2c54acc38ff3c0614d0a653813dd | MISSING | 4660 | 0 | 0 | 2009-08-21 | 2016-08-30 | 2009-08-21 | 2015-08-31 | 189.95 | 0 | 0.0 | 16.27 | 0.145711 | 0.000000 | 44.311378 | f | 0.00 | 16.38 | 16.38 | 1 | 18.89 | 6 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 13.800 | 0 |
| 2 | 764c75f661154dac3a6c254cd082ea7d | foosdfpfkusacimwkcsosbicdxkicaua | 544 | 0 | 0 | 2010-04-16 | 2016-04-16 | 2010-04-16 | 2015-04-17 | 47.96 | 0 | 0.0 | 38.72 | 0.165794 | 0.087899 | 44.311378 | f | 0.00 | 28.60 | 28.60 | 1 | 6.60 | 6 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 13.856 | 0 |
| 3 | bba03439a292a1e166f80264c16191cb | lmkebamcaaclubfxadlmueccxoimlema | 1584 | 0 | 0 | 2010-03-30 | 2016-03-30 | 2010-03-30 | 2015-03-31 | 240.04 | 0 | 0.0 | 19.83 | 0.146694 | 0.000000 | 44.311378 | f | 0.00 | 30.22 | 30.22 | 1 | 25.46 | 6 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 13.200 | 0 |
| 4 | 149d57cf92fc41cf94415803a877cb4b | MISSING | 4425 | 0 | 526 | 2010-01-13 | 2016-03-07 | 2010-01-13 | 2015-03-09 | 445.75 | 526 | 0.0 | 131.73 | 0.116900 | 0.100015 | 40.606701 | f | 52.32 | 44.91 | 44.91 | 1 | 47.98 | 6 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 19.800 | 0 |
| 5 | 1aa498825382410b098937d65c4ec26d | usilxuppasemubllopkaafesmlibmsdf | 8302 | 0 | 1998 | 2011-12-09 | 2016-12-09 | 2015-11-01 | 2015-12-10 | 796.94 | 1998 | 0.0 | 30.12 | 0.164775 | 0.086131 | 45.308378 | f | 181.21 | 33.12 | 33.12 | 1 | 118.89 | 4 | lxidpiddsbxsbosboudacockeimpuepw | 13.200 | 1 |
| 6 | 7ab4bf4878d8f7661dfc20e9b8e18011 | foosdfpfkusacimwkcsosbicdxkicaua | 45097 | 0 | 0 | 2011-12-02 | 2016-12-02 | 2011-12-02 | 2015-12-03 | 8069.28 | 0 | 0.0 | 0.00 | 0.166178 | 0.087538 | 44.311378 | f | 0.00 | 4.04 | 4.04 | 1 | 346.63 | 4 | lxidpiddsbxsbosboudacockeimpuepw | 15.000 | 1 |
| 7 | 01495c955be7ec5e7f3203406785aae0 | foosdfpfkusacimwkcsosbicdxkicaua | 29552 | 0 | 1260 | 2010-04-21 | 2016-04-21 | 2010-04-21 | 2015-04-22 | 864.73 | 751 | 0.0 | 144.49 | 0.115174 | 0.098837 | 40.606701 | f | 70.63 | 53.92 | 53.92 | 1 | 100.09 | 6 | lxidpiddsbxsbosboudacockeimpuepw | 26.400 | 0 |
| 8 | f53a254b1115634330c12c7fdbf7958a | usilxuppasemubllopkaafesmlibmsdf | 2962 | 0 | 0 | 2011-09-23 | 2016-09-23 | 2011-09-23 | 2015-09-25 | 444.38 | 0 | 0.0 | 15.85 | 0.145711 | 0.000000 | 44.311378 | f | 0.00 | 12.82 | 12.82 | 1 | 42.59 | 4 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 13.200 | 0 |
| 9 | 10c1b2f97a2d2a6f10299dc213d1a370 | lmkebamcaaclubfxadlmueccxoimlema | 26064 | 0 | 2188 | 2010-05-04 | 2016-05-04 | 2015-04-29 | 2015-05-05 | 2738.10 | 2188 | 0.0 | 130.43 | 0.115761 | 0.099419 | 40.606701 | f | 219.59 | 33.42 | 33.42 | 1 | 329.60 | 6 | lxidpiddsbxsbosboudacockeimpuepw | 31.500 | 0 |
| id | channel_sales | cons_12m | cons_gas_12m | cons_last_month | date_activ | date_end | date_modif_prod | date_renewal | forecast_cons_12m | forecast_cons_year | forecast_discount_energy | forecast_meter_rent_12m | forecast_price_energy_off_peak | forecast_price_energy_peak | forecast_price_pow_off_peak | has_gas | imp_cons | margin_gross_pow_ele | margin_net_pow_ele | nb_prod_act | net_margin | num_years_antig | origin_up | pow_max | churn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14596 | c3f4f737d598a1b47a94440bb18c3c06 | lmkebamcaaclubfxadlmueccxoimlema | 1097 | 0 | 0 | 2011-02-09 | 2016-02-09 | 2011-02-09 | 2015-02-11 | 165.60 | 0 | 0.0 | 16.04 | 0.146694 | 0.000000 | 44.311378 | f | 0.00 | 26.04 | 26.04 | 1 | 17.38 | 5 | ldkssxwpmemidmecebumciepifcamkci | 10.392 | 0 |
| 14597 | ae818f3cc00ef5845416699aacc4bd7e | ewpakwlliwisiwduibdlfmalxowmwpci | 8310 | 0 | 685 | 2012-12-18 | 2016-12-18 | 2012-12-18 | 2015-12-21 | 833.05 | 685 | 0.0 | 131.76 | 0.115237 | 0.100123 | 40.939027 | f | 67.03 | 24.02 | 24.02 | 1 | 102.52 | 3 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 23.100 | 0 |
| 14598 | 1582ef35fbfa265e60bb3399bdebac87 | MISSING | 9441 | 0 | 480 | 2009-10-08 | 2016-10-08 | 2015-05-24 | 2015-10-09 | 983.97 | 480 | 0.0 | 132.11 | 0.115237 | 0.100123 | 40.939027 | f | 46.98 | 20.00 | 20.00 | 1 | 113.17 | 6 | ldkssxwpmemidmecebumciepifcamkci | 15.001 | 0 |
| 14599 | 46362cb1ad2fcdad347a6fa1bc1e5d4b | foosdfpfkusacimwkcsosbicdxkicaua | 18163 | 3036 | 0 | 2010-01-26 | 2017-01-26 | 2015-11-17 | 2016-01-27 | 2663.82 | 0 | 0.0 | 16.35 | 0.143575 | 0.000000 | 44.311378 | t | 0.00 | 31.20 | 31.20 | 3 | 254.81 | 6 | kamkkxfxxuwbdslkwifmmcsiusiuosws | 13.856 | 0 |
| 14600 | c49217f16a06263e5381eaba94a67a8b | foosdfpfkusacimwkcsosbicdxkicaua | 87146 | 0 | 11367 | 2013-02-08 | 2016-02-08 | 2013-02-08 | 2015-02-09 | 712.33 | 713 | 0.0 | 145.82 | 0.120372 | 0.103487 | 40.606701 | f | 71.81 | 66.00 | 66.00 | 1 | 87.14 | 3 | lxidpiddsbxsbosboudacockeimpuepw | 26.400 | 0 |
| 14601 | 18463073fb097fc0ac5d3e040f356987 | foosdfpfkusacimwkcsosbicdxkicaua | 32270 | 47940 | 0 | 2012-05-24 | 2016-05-08 | 2015-05-08 | 2014-05-26 | 4648.01 | 0 | 0.0 | 18.57 | 0.138305 | 0.000000 | 44.311378 | t | 0.00 | 27.88 | 27.88 | 2 | 381.77 | 4 | lxidpiddsbxsbosboudacockeimpuepw | 15.000 | 0 |
| 14602 | d0a6f71671571ed83b2645d23af6de00 | foosdfpfkusacimwkcsosbicdxkicaua | 7223 | 0 | 181 | 2012-08-27 | 2016-08-27 | 2012-08-27 | 2015-08-28 | 631.69 | 181 | 0.0 | 144.03 | 0.100167 | 0.091892 | 58.995952 | f | 15.94 | 0.00 | 0.00 | 1 | 90.34 | 3 | lxidpiddsbxsbosboudacockeimpuepw | 6.000 | 1 |
| 14603 | 10e6828ddd62cbcf687cb74928c4c2d2 | foosdfpfkusacimwkcsosbicdxkicaua | 1844 | 0 | 179 | 2012-02-08 | 2016-02-07 | 2012-02-08 | 2015-02-09 | 190.39 | 179 | 0.0 | 129.60 | 0.116900 | 0.100015 | 40.606701 | f | 18.05 | 39.84 | 39.84 | 1 | 20.38 | 4 | lxidpiddsbxsbosboudacockeimpuepw | 15.935 | 1 |
| 14604 | 1cf20fd6206d7678d5bcafd28c53b4db | foosdfpfkusacimwkcsosbicdxkicaua | 131 | 0 | 0 | 2012-08-30 | 2016-08-30 | 2012-08-30 | 2015-08-31 | 19.34 | 0 | 0.0 | 7.18 | 0.145711 | 0.000000 | 44.311378 | f | 0.00 | 13.08 | 13.08 | 1 | 0.96 | 3 | lxidpiddsbxsbosboudacockeimpuepw | 11.000 | 0 |
| 14605 | 563dde550fd624d7352f3de77c0cdfcd | MISSING | 8730 | 0 | 0 | 2009-12-18 | 2016-12-17 | 2009-12-18 | 2015-12-21 | 762.41 | 0 | 0.0 | 1.07 | 0.167086 | 0.088454 | 45.311378 | f | 0.00 | 11.84 | 11.84 | 1 | 96.34 | 6 | ldkssxwpmemidmecebumciepifcamkci | 10.392 | 0 |